package com.tenebrous.jestic.mapper.idao.framwork.system;

import com.tenebrous.jestic.entity.framwork.system.SysSchedule;
import com.tenebrous.jestic.mapper.ISuperMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

//@Mapper
public interface SysScheduleMapper extends ISuperMapper<SysSchedule> {

    @Select("SELECT * FROM SYS_SCHEDULE A WHERE A.STIME=#{stime} AND A.CREATE_USERID=#{userid} ORDER BY A.SORT,A.CREATE_DATE")
    List<SysSchedule> selectByStime(@Param("stime") String stime, @Param("userid") String userid);

    @Select("SELECT * FROM SYS_SCHEDULE A WHERE A.SYEAR=#{syear} AND A.SMONTH=#{smonth} AND A.CREATE_USERID=#{userid} ORDER BY A.SORT,A.CREATE_DATE")
    List<SysSchedule> selectByCondition(@Param("syear") String syear, @Param("smonth") String smonth, @Param("userid") String userid);
}